package com.hs.mapper;

import com.hs.entity.Consultant;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface ConsultantMapper {
    //添加
    Integer addConsultant(Consultant consultant);
    //删除
    Integer deleteConsultant(Integer id);
    //修改
    Integer updateConsultant(Consultant consultant);
    //根据id查询
    Consultant getConsultantById(Integer id);
    //分页查询
    List<Consultant> getAllConsultantByPage();

    List<Consultant> getAllConsultantlist(Consultant consultant);

    List<Consultant> getConsultantByLevelName(@Param("levelName") String levelName,@Param("tag") String tag,@Param("address") String dq,@Param("gender") String gender);
    List<Consultant> getConsultantByLevelNameAndTag(@Param("levelName") String levelName,@Param("tag") String tag);
}
